Stored Procedures [dbo].[BAEUpdateBatchInformation]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@orderNumfloat8
@taxDifferenceAmountmoney8
SQL Script
create procedure [dbo].[BAEUpdateBatchInformation] @orderNum float,
     @taxDifferenceAmount MONEY as
DECLARE    @batchNum VARCHAR(16)

SELECT    @batchNum = BATCH_NUM
FROM        Orders
WHERE    ORDER_NUMBER = @orderNum;

UPDATE    Batch
SET        CONTROL_CASH = ( CONTROL_CASH + @taxDifferenceAmount ),
        TRANS_CASH = ( TRANS_CASH + @taxDifferenceAmount)
WHERE    BATCH_NUM = @batchNum;

GO
Uses